Using CCC Search
The search function allows you to search the objects in a list, and is displayed at the top of all object lists. Enter a string you want to search for to filter the list to display only matching records.
A limited set of regular expression operators are supported to provide advance search capabilities. If you want to search for a string that contains a character that is used as a regular expression operator, you must put a '\' before the character to escape the special character. For example, 'Finance$' would search for table entries with "Finance" at the end, while 'Finance\$' would search for table entries that contained "Finance$".
The search strings are not case sensitive.
Using Regular Expression Operators
You can use the following special characters to search using regular expressions. To search for a string that contains one of these operators, you must escape the operator by prefixing it with a backslash ().
| Character | Experssion |
|---|---|
| ^ | Search for a string that begins with a specific character string. Do not include spaces after the ^ operator. For example: ^fred matches all records that begin with the string "Fred". It would match "Fred", but not "Alfred". |
| $ | Search for a string that ends with a specific character string. Do not include spaces after the $ operator. For example: fred$ matches all records that end with the string "fred". It would match "Alfred", but not "Freddy". |
| * | Match any number of random characters. You cannot use the * operator as the first character in the search string. Do not include spaces before or after the * operator. For example: f*d matches all records that contain a string that begins with f and end with d. It matches Fred, fried, deepfried, friend, friends, myfriend, etc. |
| . | Match a single random character. Do not include spaces before or after the . operator. For example: fre. matches all records that contain a string that begins with fre and ends with any random character. It matches fred, fret, frets, alfred, whyfret, etc. |
| : | Search for a string in a specific column. Do not include spaces before or after the : operator. For example: Name:Bob matches all records that contain the string "Bob" in the Name column. You can use the ; character as a separator in a multi-column search. For example: Name:Bob;Role:Admin matches all records that contain the string "Bob" in the Name column and "Admin" in the Role column. You can use the ^, $, *, or . operators within the search string for a specific column. |